Use QuanLyKho
GO
CREATE PROC insertHangHoa 
	@maHang varchar(50) ,
	@tenHang nvarchar(500),
	@ngayNhap datetime ,
	@soLuong int,
	@donGia float ,
	@donViTinh varchar(50),
	@nhId int 
AS
BEGIN
	Insert into hangHoa values(@maHang,@tenHang,@ngayNhap,@soLuong,@donGia,@donViTinh,@nhId)
END
GO
------------------------------------------------------------
CREATE PROC getAllHangHoa
AS
SELECT     hanghoa.*, nhomHang.tenNhomHang
FROM         hanghoa INNER JOIN
                      nhomHang ON hanghoa.nhId = nhomHang.nhId
GO


